package com.jluzh10.learning.dao;

import com.jluzh10.learning.domain.CommentParame;

public interface CommentParameMapper {
    /**
     *
     * @param courseId
     * @return
     */
    public CommentParame findCommentParame(int courseId);

    /**
     * 计算总分
     * @param courseId
     * @return
     */
    public double sumScope(int courseId);

    /**
     * 计算五星所占百分比
     * @param courseId
     * @return
     */
    public double avgFiveStart(int courseId);

    /**
     * 计算四星所占百分比
     * @param courseId
     * @return
     */
    public double avgFouStart(int courseId);

    /**
     * 计算三星所占百分比
     * @param courseId
     * @return
     */
    public double avgThreeStart(int courseId);

    /**
     * 计算二星所占百分比
     * @param courseId
     * @return
     */
    public double avgTwoStart(int courseId);

    /**
     * 计算一星所占百分比
     * @param courseId
     * @return
     */
    public double avgOneStart(int courseId);
}
